UPDATE FLW_ID_DATABASECHANGELOGLOCK SET LOCKED = TRUE, LOCKEDBY = 'Tijs-new-macbook-pro.local (192.168.68.127)', LOCKGRANTED = CURRENT TIMESTAMP WHERE ID = 1 AND LOCKED = FALSE;


ALTER TABLE FLW_IDENTITY_INFO ADD GROUP_ID_REF_ VARCHAR(64);

CALL SYSPROC.ADMIN_CMD ('REORG TABLE FLW_IDENTITY_INFO');

ALTER TABLE FLW_IDENTITY_INFO DROP CONSTRAINT FLW_UQ_ID_INFO_TENANT_USR_NAME;

ALTER TABLE FLW_IDENTITY_INFO ALTER COLUMN  USER_ID_ DROP NOT NULL;

CALL SYSPROC.ADMIN_CMD ('REORG TABLE FLW_IDENTITY_INFO');

INSERT INTO FLW_ID_DATABASECHANGELOG (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, DEPLOYMENT_ID) VALUES ('20', 'flowable', 'com/flowable/platform/idm/db/liquibase/flowable-idm-db-changelog.xml', CURRENT TIMESTAMP, 20, '9:4fa29c6e3fd618a9c1fb6fab39338378', 'addColumn tableName=FLW_IDENTITY_INFO; dropUniqueConstraint constraintName=FLW_UQ_ID_INFO_TENANT_USR_NAME, tableName=FLW_IDENTITY_INFO; dropNotNullConstraint columnName=USER_ID_, tableName=FLW_IDENTITY_INFO', '', 'EXECUTED', NULL, NULL, '4.27.0', '9305411748');

UPDATE FLW_ID_DATABASECHANGELOGLOCK SET LOCKED = FALSE, LOCKEDBY = NULL, LOCKGRANTED = NULL WHERE ID = 1;

UPDATE FLW_LIC_DATABASECHANGELOGLOCK SET LOCKED = TRUE, LOCKEDBY = 'Tijs-new-macbook-pro.local (192.168.68.127)', LOCKGRANTED = CURRENT TIMESTAMP WHERE ID = 1 AND LOCKED = FALSE;


UPDATE FLW_LIC_DATABASECHANGELOGLOCK SET LOCKED = FALSE, LOCKEDBY = NULL, LOCKGRANTED = NULL WHERE ID = 1;

UPDATE FLW_PL_DATABASECHANGELOGLOCK SET LOCKED = TRUE, LOCKEDBY = 'Tijs-new-macbook-pro.local (192.168.68.127)', LOCKGRANTED = CURRENT TIMESTAMP WHERE ID = 1 AND LOCKED = FALSE;


CREATE TABLE FLW_OAUTH_CLIENT_REG (ID_ VARCHAR(255) NOT NULL, REGISTRATION_KEY_ VARCHAR(255) NOT NULL, CLIENT_ID_ VARCHAR(100) NOT NULL, CLIENT_SECRET_ VARCHAR(255), CLIENT_NAME_ VARCHAR(255), CLIENT_AUTHENTICATION_METHOD_ VARCHAR(200), SCOPES_ VARCHAR(2000), ISSUER_URI_ VARCHAR(2000), TOKEN_URI_ VARCHAR(2000), TENANT_ID_ VARCHAR(255), CONSTRAINT FLW_PK_OAUTH_CLIENT_REG PRIMARY KEY (ID_));

INSERT INTO FLW_PL_DATABASECHANGELOG (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, DEPLOYMENT_ID) VALUES ('14', 'flowable', 'com/flowable/platform/db/liquibase/flowable-platform-db-changelog.xml', CURRENT TIMESTAMP, 14, '9:906169834fe444cee66b28d619149208', 'createTable tableName=FLW_OAUTH_CLIENT_REG', '', 'EXECUTED', NULL, NULL, '4.27.0', '9305412701');

UPDATE FLW_PL_DATABASECHANGELOGLOCK SET LOCKED = FALSE, LOCKEDBY = NULL, LOCKGRANTED = NULL WHERE ID = 1;

UPDATE ACT_APP_DATABASECHANGELOGLOCK SET LOCKED = TRUE, LOCKEDBY = 'Tijs-new-macbook-pro.local (192.168.68.127)', LOCKGRANTED = CURRENT TIMESTAMP WHERE ID = 1 AND LOCKED = FALSE;


ALTER TABLE ACT_APP_APPDEF ADD CREATION_TIME_ TIMESTAMP(6);

ALTER TABLE ACT_APP_APPDEF ADD CREATOR_ID_ VARCHAR(64);

CALL SYSPROC.ADMIN_CMD ('REORG TABLE ACT_APP_APPDEF');

ALTER TABLE ACT_APP_DEPLOYMENT ADD CREATOR_ID_ VARCHAR(64);

CALL SYSPROC.ADMIN_CMD ('REORG TABLE ACT_APP_DEPLOYMENT');

INSERT INTO ACT_APP_DATABASECHANGELOG (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, DEPLOYMENT_ID) VALUES ('8', 'flowable', 'org/flowable/app/db/liquibase/flowable-app-db-changelog.xml', CURRENT TIMESTAMP, 7, '9:e3a80fd68c49ee871eeadf98ff4c81d4', 'addColumn tableName=ACT_APP_APPDEF; addColumn tableName=ACT_APP_DEPLOYMENT', '', 'EXECUTED', NULL, NULL, '4.27.0', '9305413195');

UPDATE ACT_APP_DATABASECHANGELOGLOCK SET LOCKED = FALSE, LOCKEDBY = NULL, LOCKGRANTED = NULL WHERE ID = 1;

UPDATE FLW_FO_DATABASECHANGELOGLOCK SET LOCKED = TRUE, LOCKEDBY = 'Tijs-new-macbook-pro.local (192.168.68.127)', LOCKGRANTED = CURRENT TIMESTAMP WHERE ID = 1 AND LOCKED = FALSE;


UPDATE FLW_FO_DATABASECHANGELOGLOCK SET LOCKED = FALSE, LOCKEDBY = NULL, LOCKGRANTED = NULL WHERE ID = 1;

UPDATE FLW_CO_DATABASECHANGELOGLOCK SET LOCKED = TRUE, LOCKEDBY = 'Tijs-new-macbook-pro.local (192.168.68.127)', LOCKGRANTED = CURRENT TIMESTAMP WHERE ID = 1 AND LOCKED = FALSE;


UPDATE FLW_CO_DATABASECHANGELOGLOCK SET LOCKED = FALSE, LOCKEDBY = NULL, LOCKGRANTED = NULL WHERE ID = 1;

UPDATE FLW_AD_DATABASECHANGELOGLOCK SET LOCKED = TRUE, LOCKEDBY = 'Tijs-new-macbook-pro.local (192.168.68.127)', LOCKGRANTED = CURRENT TIMESTAMP WHERE ID = 1 AND LOCKED = FALSE;


UPDATE FLW_AD_DATABASECHANGELOGLOCK SET LOCKED = FALSE, LOCKEDBY = NULL, LOCKGRANTED = NULL WHERE ID = 1;

UPDATE FLW_AU_DATABASECHANGELOGLOCK SET LOCKED = TRUE, LOCKEDBY = 'Tijs-new-macbook-pro.local (192.168.68.127)', LOCKGRANTED = CURRENT TIMESTAMP WHERE ID = 1 AND LOCKED = FALSE;


UPDATE FLW_AU_DATABASECHANGELOGLOCK SET LOCKED = FALSE, LOCKEDBY = NULL, LOCKGRANTED = NULL WHERE ID = 1;

UPDATE FLW_DO_DATABASECHANGELOGLOCK SET LOCKED = TRUE, LOCKEDBY = 'Tijs-new-macbook-pro.local (192.168.68.127)', LOCKGRANTED = CURRENT TIMESTAMP WHERE ID = 1 AND LOCKED = FALSE;


UPDATE FLW_DO_DATABASECHANGELOGLOCK SET LOCKED = FALSE, LOCKEDBY = NULL, LOCKGRANTED = NULL WHERE ID = 1;

UPDATE FLW_PO_DATABASECHANGELOGLOCK SET LOCKED = TRUE, LOCKEDBY = 'Tijs-new-macbook-pro.local (192.168.68.127)', LOCKGRANTED = CURRENT TIMESTAMP WHERE ID = 1 AND LOCKED = FALSE;


UPDATE FLW_PO_DATABASECHANGELOGLOCK SET LOCKED = FALSE, LOCKEDBY = NULL, LOCKGRANTED = NULL WHERE ID = 1;

UPDATE FLW_SE_DATABASECHANGELOGLOCK SET LOCKED = TRUE, LOCKEDBY = 'Tijs-new-macbook-pro.local (192.168.68.127)', LOCKGRANTED = CURRENT TIMESTAMP WHERE ID = 1 AND LOCKED = FALSE;


UPDATE FLW_SE_DATABASECHANGELOGLOCK SET LOCKED = FALSE, LOCKEDBY = NULL, LOCKGRANTED = NULL WHERE ID = 1;

UPDATE FLW_TP_DATABASECHANGELOGLOCK SET LOCKED = TRUE, LOCKEDBY = 'Tijs-new-macbook-pro.local (192.168.68.127)', LOCKGRANTED = CURRENT TIMESTAMP WHERE ID = 1 AND LOCKED = FALSE;


UPDATE FLW_TP_DATABASECHANGELOGLOCK SET LOCKED = FALSE, LOCKEDBY = NULL, LOCKGRANTED = NULL WHERE ID = 1;

UPDATE FLW_ENG_DATABASECHANGELOGLOCK SET LOCKED = TRUE, LOCKEDBY = 'Tijs-new-macbook-pro.local (192.168.68.127)', LOCKGRANTED = CURRENT TIMESTAMP WHERE ID = 1 AND LOCKED = FALSE;


UPDATE FLW_ENG_DATABASECHANGELOGLOCK SET LOCKED = FALSE, LOCKEDBY = NULL, LOCKGRANTED = NULL WHERE ID = 1;

